|
phpPgAdmin - Operate from Web browser
2011/06/18 |
|
Install phpPgAdmin and operate PostgreSQL from Web browser. Web server is also required.
|
|
| [1] | Install and configure phpPgAdmin |
|
[root@www ~]#
vi /etc/phpPgAdmin/config.inc.php # line 18: add $conf['servers'][0]['host'] = ' localhost ';
# line 88: change $conf['extra_login_security'] = false ;
# line 94: change $conf['owned_only'] = true ;
[root@www ~]#
vi /var/lib/pgsql/data/pg_hba.conf # line 70: change local all all md5 # line 72: change and add the IP range you permit local all all 127.0.0.1/32 md5 local
all all 10.0.0.0/24 md5 # line 75: change local all all ::1/128 md5
[root@www ~]#
vi /etc/httpd/conf.d/phpPgAdmin.conf # line 11: add IP range you permit Allow from 127.0.0.1 10.0.0.0/24 /etc/rc.d/init.d/postgresql restart Stopping postgresql service: [ OK ] Starting postgresql service: [ OK ] [root@www ~]# /etc/rc.d/init.d/httpd reload Reloading httpd: [ OK ] |
| [2] | Access to "http://(hostname or IP address)/phpPgAdmin/" and click "PostgreSQL" on the left. |
|
| [3] | Authenticate with a user you added in PostgreSQL. |
|
| [4] | Just logined. It's possible to operate PostgreSQL Database on here. |
|